import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;


public class HsqlTest {

public static void main( String[] args ) throws Exception {
Class.forName("org.hsqldb.jdbcDriver");
Connection con = DriverManager.getConnection("jdbc:hsqldb:file:c/Datenbank/hsqldb/", "kaiser", "8459191");

String sqlQuery = null;

Statement stmt = con.createStatement(); 

sqlQuery = "CREATE TABLE spieler (ID INTEGER, vorname CHAR(20), nachname CHAR(20));";
stmt.executeUpdate(sqlQuery);


sqlQuery = "INSERT INTO spieler VALUES (1,'Patrick','S');";
stmt.executeUpdate(sqlQuery);
sqlQuery = "INSERT INTO spieler VALUES (2,'Daniel','B');";
stmt.executeUpdate(sqlQuery);
sqlQuery = "INSERT INTO spieler VALUES (3,'Alex','F');";
stmt.executeUpdate(sqlQuery);

con.prepareStatement("SHUTDOWN").execute();
con.commit();
}

} 